Compulsory
DATABASES
- GENERAL
-
TEACHING METHODS: TEACHING HOURS
(WEEKLY)
Lectures and Recitations 2 Tutorials 1 Total 3 COURSE TYPE: Special field COURSE PREREQUISITES: None TEACHING LANGUAGE: Greek THE COURSE IS OFFERED TO ERASMUS STUDENTS: Yes (in English) - LEARNIING RESULTS
-
Course Description and Learning Objectives The course objective is to give to the students a good understanding about the processes of data management so as to be able to define, design, analyze and take full advantage of business data according to the rules and procedures of database design principles.
Students learn the fundamental concepts of database design and development procedures. Upon successful completion of this course, students will be able to demonstrate an understanding on:
• Design and management of databases
• Database management software tools
• Data warehouse and data-mining procedures
Competencies Decision-making
Autonomous working
Collaborative working
Advancement of a free, productive and inductive mind
Access, analysis, synthesis and display command of existing knowledge through state of the art tools
Acquisition of the necessary conceptual and theoretical background through an interdisciplinary approach
- CONTENT
-
THEORY
Fundamentals terms of databases
Internal architecture of database systems
Abstraction levels (Conceptual, Logical and Physical Layer)
Database Models
Relational data model (Relational Model description, Relations, relational schemas)
Keys (Super keys, candidate keys, primary, foreign). Value atomicity, auto-relationships, N-tuple relationships, schemas equivalence
Logical design of relational databases
Conceptual data representation. Entity-Relationship model (E-R model). E-R model limitations
Functional dependency. Partial and transitional functional dependencies
Normal Forms (1NF, 2NF, 3NF). Objectives and algorithms of Normalization
Relational Algebra
Introduction to the SQL Language. Structure of fundamental commands (SELECT, UPDATE, INSERT, DELETE)
Introduction to administration of database management systems
- TEACHING and LEARNING METHODS - EVALUATION\
-
TEACHING METHOD In class
Asynchronous teaching through the eClass platform
USE OF INFORMATION AND COMMUNICATION TECHNOLOGIES The teaching and learning process is supported by the electronic platform of e-class
Communication with students through eClass
Exercise solving with DBMS systems
Further reading content that is available as opencourcses through the web
METHODS OF INSTRUCTION Method Semester workload Lectures 39 In recitations that supplement lectures, the instructor reviews the lecture, expands on the concepts, carries on discussions with the students.. 36 Shelf-study 75 Total workload in hours 150 STUDENT LEARNING ASSESMENT Language of Assessment: Greek, (English for ERASMUS)
Method of Assessment in three different forms:
Intermediate assessment during 7th or 8th week (20%)
Exercises solving during the tutorials classes (20%)
Written term exam (60%) that includes:
-Multiple choice questions
-Short answer questions
-Problem-solving
- RECOMMENDED-BIBLIOGRAPHY
-
Ταμπακάς Β. «Εισαγωγή στις Βάσεις Δεδομένων», ISBN: 978-960-931217-2, 2009, Εκδόσεις Βασίλειος Ταμπακάς.
Σχεσιακές βάσεις δεδομένων - Νέα αναθεωρημένη έκδοση, Κεχρής Ευάγγελος, 2η έκδοση, 2015, ISBN: 978-960-218-928-3, ΕΚΔΟΣΕΙΣ ΚΡΙΤΙΚΗ ΑΕ
Δέρβος Δ., «Μαθήματα Βάσεων Δεδομένων», Τόμος Α, ISBN: 978-960-7219-38-1, Εκδόσεις Α. Τζιόλα.
Date C.J. «Εισαγωγή στις Βάσεις Δεδομένων, Τόμος Α », Εκδόσεις Κλειδάριθμος, 6η έκδοση
Elmasri Ramez, Navathe Shamkant B. «Θεμελιώδεις Αρχές Συστημάτων Βάσεων δεδομένων», ISBN: 978-960-531-281-7, 6η έκδοση, Εκδόσεις Δίαυλος, 2012.
Connolly Th. M., Begg C. E., «Database Systems: A Practical Approach to Design, Implementation and Management», Addison Wesley, 2009.